{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Year 1-6","Year 7-12","Year 13-18","Year 19-24","Year 25-30","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Year 1-6","index":0,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Fred/Lynette's Loan",null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06,null,null,"FULLY PAID OFF"]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[1999,null,null,"Total","Loan",null,2002,null,null,"Total","Loan"]
["Year 1","Principle","Interest","Payment","Balance",null,"Year 4","Principle","Interest","Payment","Balance"]
["Payment 1",21.29,106.97,128.26,21372.07,null,"Payment 1",47.59,80.67,128.26,15087.129999999996]
["Payment 2",21.4,106.86,128.26,21350.67,null,"Payment 2",52.82,75.44,128.26,15034.309999999996]
["Payment 3",21.51,106.75,128.26,21329.16,null,"Payment 3",53.09,75.17,128.26,14981.219999999996]
["Payment 4",21.61,106.65,128.26,21307.55,null,"Payment 4",53.35,74.91,128.26,14927.869999999995]
["Payment 5",21.72,106.54,128.26,21285.829999999998,null,"Payment 5",53.62,74.64,128.26,14874.249999999995]
["Payment 6",21.83,106.43,128.26,21263.999999999996,null,"Payment 6",53.89,74.37,128.26,14820.359999999995]
["Payment 7",21.94,106.32,128.26,21242.059999999998,null,"Payment 7",54.16,74.1,128.26,14766.199999999995]
["Payment 8",22.05,106.21,128.26,21220.01,null,"Payment 8",54.43,73.83,128.26,14711.769999999995]
["Payment 9",22.16,106.1,128.26,21197.85,null,"Payment 9",54.7,73.56,128.26,14657.069999999994]
["Payment 10",22.27,105.99,128.26,21175.579999999998,null,"Payment 10",54.97,73.29,128.26,14602.099999999995]
["Payment 11",22.38,105.88,128.26,21153.199999999997,null,"Payment 11",55.25,73.01,128.26,14546.849999999995]
["Payment 12",22.49,105.77,128.26,21130.709999999995,null,"Payment 12",55.53,72.73,128.26,14491.319999999994]
["     Gift",3000,null,3000,18130.709999999995,null,"     Gift",1000,null,1000,13491.319999999994]
["Total Year 1",3262.65,1276.4699999999998,4539.12,null,null,"Total Year 4",1643.4,895.72,2539.12]
[]
[2000,null,null,"Total","Loan",null,2003,null,null,"Total","Loan"]
["Year 2","Principle","Interest","Payment","Balance",null,"Year 5","Principle","Interest","Payment","Balance"]
["Payment 1",22.61,105.65,128.26,18108.099999999995,null,"Payment 1",55.8,72.46,128.26,13435.519999999995]
["Payment 2",37.72,90.54,128.26,18070.379999999994,null,"Payment 2",61.08,67.18,128.26,13374.439999999995]
["Payment 3",37.91,90.35,128.26,18032.469999999994,null,"Payment 3",61.39,66.87,128.26,13313.049999999996]
["Payment 4",38.1,90.16,128.26,17994.369999999995,null,"Payment 4",61.69,66.57,128.26,13251.359999999995]
["Payment 5",38.29,89.97,128.26,17956.079999999994,null,"Payment 5",62,66.26,128.26,13189.359999999995]
["Payment 6",38.48,89.78,128.26,17917.599999999995,null,"Payment 6",62.31,65.95,128.26,13127.049999999996]
["Payment 7",38.67,89.59,128.26,17878.929999999997,null,"Payment 7",62.62,65.64,128.26,13064.429999999995]
["Payment 8",38.87,89.39,128.26,17840.059999999998,null,"Payment 8",62.94,65.32,128.26,13001.489999999994]
["Payment 9",39.06,89.2,128.26,17800.999999999996,null,"Payment 9",63.25,65.01,128.26,12938.239999999994]
["Payment 10",39.25,89.01,128.26,17761.749999999996,null,"Payment 10",63.57,64.69,128.26,12874.669999999995]
["Payment 11",39.45,88.81,128.26,17722.299999999996,null,"Payment 11",63.89,64.37,128.26,12810.779999999995]
["Payment 12",39.65,88.61,128.26,17682.649999999994,null,"Payment 12",64.21,64.05,128.26,12746.569999999996]
["     Gift",1000,null,1000,16682.649999999994,null,"     Gift",1000,null,1000,11746.569999999996]
["Total Year 2",1448.06,1091.06,2539.12,null,null,"Total Year 5",1744.75,794.37,2539.12]
[]
[2001,null,null,"Total","Loan",null,2004,null,null,"Total","Loan"]
["Year 3","Principle","Interest","Payment","Balance",null,"Year 6","Principle","Interest","Payment","Balance"]
["Payment 1",39.85,88.41,128.26,16642.799999999996,null,"Payment 1",64.53,63.73,128.26,11682.039999999995]
["Payment 2",45.05,83.21,128.26,16597.749999999996,null,"Payment 2",69.85,58.41,128.26,11612.189999999995]
["Payment 3",45.27,82.99,128.26,16552.479999999996,null,"Payment 3",70.2,58.06,128.26,11541.989999999994]
["Payment 4",45.5,82.76,128.26,16506.979999999996,null,"Payment 4",70.55,57.71,128.26,11471.439999999995]
["Payment 5",45.73,82.53,128.26,16461.249999999996,null,"Payment 5",70.9,57.36,128.26,11400.539999999995]
["Payment 6",45.95,82.31,128.26,16415.299999999996,null,"Payment 6",71.26,57,128.26,11329.279999999995]
["Payment 7",46.18,82.08,128.26,16369.119999999995,null,"Payment 7",71.61,56.65,128.26,11257.669999999995]
["Payment 8",46.41,81.85,128.26,16322.709999999995,null,"Payment 8",71.97,56.29,128.26,11185.699999999995]
["Payment 9",46.65,81.61,128.26,16276.059999999996,null,"Payment 9",72.33,55.93,128.26,11113.369999999995]
["Payment 10",46.88,81.38,128.26,16229.179999999997,null,"Payment 10",72.69,55.57,128.26,11040.679999999995]
["Payment 11",47.11,81.15,128.26,16182.069999999996,null,"Payment 11",73.06,55.2,128.26,10967.619999999995]
["Payment 12",47.35,80.91,128.26,16134.719999999996,null,"Payment 12",73.42,54.84,128.26,10894.199999999995]
["     Gift",1000,null,1000,15134.719999999996,null,"     Gift",0,null,0,10894.199999999995]
["Total Year 3",1547.93,991.1899999999999,2539.12,null,null,"Total Year 6",852.37,686.7500000000001,1539.12]

{"sheet":"Year 7-12","index":1,"n_rows":57,"n_cols":11,"rows_kept":57,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[2005,null,null,"Total","Loan",null,2008,null,null,"Total","Loan"]
["Year 7","Principle","Interest","Payment","Balance",null,"Year 10","Principle","Interest","Payment","Balance"]
["Payment 1",73.79,54.47,128.26,10820.409999999994,null,"Payment 1",88.3,39.96,128.26,7903.29999999999]
["Payment 2",74.16,54.1,128.26,10746.249999999995,null,"Payment 2",88.74,39.52,128.26,7814.55999999999]
["Payment 3",74.53,53.73,128.26,10671.719999999994,null,"Payment 3",89.19,39.07,128.26,7725.369999999991]
["Payment 4",74.9,53.36,128.26,10596.819999999994,null,"Payment 4",89.63,38.63,128.26,7635.739999999991]
["Payment 5",75.28,52.98,128.26,10521.539999999994,null,"Payment 5",90.08,38.18,128.26,7545.659999999991]
["Payment 6",75.65,52.61,128.26,10445.889999999994,null,"Payment 6",90.53,37.73,128.26,7455.129999999991]
["Payment 7",76.03,52.23,128.26,10369.859999999993,null,"Payment 7",90.98,37.28,128.26,7364.149999999991]
["Payment 8",76.41,51.85,128.26,10293.449999999993,null,"Payment 8",91.44,36.82,128.26,7272.709999999992]
["Payment 9",76.79,51.47,128.26,10216.659999999993,null,"Payment 9",91.9,36.36,128.26,7180.809999999992]
["Payment 10",77.18,51.08,128.26,10139.479999999992,null,"Payment 10",92.36,35.9,128.26,7088.4499999999925]
["Payment 11",77.56,50.7,128.26,10061.919999999993,null,"Payment 11",92.82,35.44,128.26,6995.629999999993]
["Payment 12",77.95,50.31,128.26,9983.969999999992,null,"Payment 12",93.28,34.98,128.26,6902.349999999993]
["     Gift",0,null,0,9983.969999999992,null,"     Gift",0,null,0,6902.349999999993]
["Total Year 7",910.2299999999998,628.8900000000001,1539.12,null,null,"Total Year 10",1089.25,449.87,1539.12]
[]
[2006,null,null,"Total","Loan",null,2009,null,null,"Total","Loan"]
["Year 8","Principle","Interest","Payment","Balance",null,"Year 11","Principle","Interest","Payment","Balance"]
["Payment 1",78.34,49.92,128.26,9905.629999999992,null,"Payment 1",93.75,34.51,128.26,6808.599999999993]
["Payment 2",78.73,49.53,128.26,9826.899999999992,null,"Payment 2",94.22,34.04,128.26,6714.379999999993]
["Payment 3",79.13,49.13,128.26,9747.769999999993,null,"Payment 3",94.69,33.57,128.26,6619.689999999993]
["Payment 4",79.52,48.74,128.26,9668.249999999993,null,"Payment 4",95.16,33.1,128.26,6524.529999999993]
["Payment 5",79.92,48.34,128.26,9588.329999999993,null,"Payment 5",95.64,32.62,128.26,6428.889999999993]
["Payment 6",80.32,47.94,128.26,9508.009999999993,null,"Payment 6",96.12,32.14,128.26,6332.769999999993]
["Payment 7",80.72,47.54,128.26,9427.289999999994,null,"Payment 7",96.6,31.66,128.26,6236.169999999993]
["Payment 8",81.12,47.14,128.26,9346.169999999993,null,"Payment 8",97.08,31.18,128.26,6139.089999999993]
["Payment 9",81.53,46.73,128.26,9264.639999999992,null,"Payment 9",97.56,30.7,128.26,6041.5299999999925]
["Payment 10",81.94,46.32,128.26,9182.699999999992,null,"Payment 10",98.05,30.21,128.26,5943.479999999992]
["Payment 11",82.35,45.91,128.26,9100.349999999991,null,"Payment 11",98.54,29.72,128.26,5844.939999999992]
["Payment 12",82.76,45.5,128.26,9017.589999999991,null,"Payment 12",99.04,29.22,128.26,5745.899999999992]
["     Gift",0,null,0,9017.589999999991,null,"     Gift",0,null,0,5745.899999999992]
["Total Year 8",966.38,572.74,1539.12,null,null,"Total Year 11",1156.4499999999998,382.66999999999996,1539.12]
[]
[2007,null,null,"Total","Loan",null,2010,null,null,"Total","Loan"]
["Year 9","Principle","Interest","Payment","Balance",null,"Year 12","Principle","Interest","Payment","Balance"]
["Payment 1",83.17,45.09,128.26,8934.419999999991,null,"Payment 1",99.53,28.73,128.26,5646.369999999993]
["Payment 2",83.59,44.67,128.26,8850.82999999999,null,"Payment 2",100.03,28.23,128.26,5546.339999999993]
["Payment 3",84.01,44.25,128.26,8766.81999999999,null,"Payment 3",100.53,27.73,128.26,5445.809999999993]
["Payment 4",84.43,43.83,128.26,8682.38999999999,null,"Payment 4",101.03,27.23,128.26,5344.779999999993]
["Payment 5",84.85,43.41,128.26,8597.53999999999,null,"Payment 5",101.54,26.72,128.26,5243.239999999993]
["Payment 6",85.27,42.99,128.26,8512.26999999999,null,"Payment 6",102.04,26.22,128.26,5141.199999999993]
["Payment 7",85.7,42.56,128.26,8426.569999999989,null,"Payment 7",102.55,25.71,128.26,5038.649999999993]
["Payment 8",86.13,42.13,128.26,8340.43999999999,null,"Payment 8",103.07,25.19,128.26,4935.579999999994]
["Payment 9",86.56,41.7,128.26,8253.87999999999,null,"Payment 9",103.58,24.68,128.26,4831.999999999994]
["Payment 10",86.99,41.27,128.26,8166.88999999999,null,"Payment 10",104.1,24.16,128.26,4727.899999999993]
["Payment 11",87.43,40.83,128.26,8079.45999999999,null,"Payment 11",104.62,23.64,128.26,4623.279999999993]
["Payment 12",87.86,40.4,128.26,7991.59999999999,null,"Payment 12",105.14,23.12,128.26,4518.139999999993]
["     Gift",0,null,0,7991.59999999999,null,"     Gift",0,null,0,4518.139999999993]
["Total Year 9",1025.99,513.1299999999999,1539.12,null,null,"Total Year 12",1227.76,311.36,1539.12]

{"sheet":"Year 13-18","index":2,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 13","Principle","Interest","Payment","Balance",null,"Year 16","Principle","Interest","Payment","Balance"]
["Payment 1",105.67,22.59,128.26,4412.469999999993,null,"Payment 1",126.45,1.81,128.26,235.08999999999247]
["Payment 2",106.2,22.06,128.26,4306.269999999993,null,"Payment 2",127.08,1.18,128.26,108.00999999999247]
["Payment 3",106.73,21.53,128.26,4199.539999999994,null,"Payment 3",127.72,0.54,128.26,-19.710000000007526]
["Payment 4",107.26,21,128.26,4092.2799999999934,null,"Payment 4",128.36,-0.1,128.26000000000002,-148.07000000000755]
["Payment 5",107.8,20.46,128.26,3984.479999999993,null,"Payment 5",129,-0.74,128.26,-277.07000000000755]
["Payment 6",108.34,19.92,128.26,3876.139999999993,null,"Payment 6",129.65,-1.39,128.26000000000002,-406.72000000000753]
["Payment 7",108.88,19.38,128.26,3767.259999999993,null,"Payment 7",130.29,-2.03,128.26,-537.0100000000075]
["Payment 8",109.42,18.84,128.26,3657.839999999993,null,"Payment 8",130.95,-2.69,128.26,-667.9600000000075]
["Payment 9",109.97,18.29,128.26,3547.869999999993,null,"Payment 9",131.6,-3.34,128.26,-799.5600000000076]
["Payment 10",110.52,17.74,128.26,3437.349999999993,null,"Payment 10",132.26,-4,128.26,-931.8200000000076]
["Payment 11",111.07,17.19,128.26,3326.279999999993,null,"Payment 11",132.92,-4.66,128.26,-1064.7400000000075]
["Payment 12",111.63,16.63,128.26,3214.649999999993,null,"Payment 12",133.58,-5.32,128.26000000000002,-1198.3200000000074]
["Total Year 13",1303.4899999999998,235.63000000000002,1539.12,null,null,"Total Year 16",1559.86,-20.74,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 14","Principle","Interest","Payment","Balance",null,"Year 17","Principle","Interest","Payment","Balance"]
["Payment 1",112.19,16.07,128.26,3102.4599999999928,null,"Payment 1",134.25,-5.99,128.26,-1332.5700000000074]
["Payment 2",112.75,15.51,128.26,2989.7099999999928,null,"Payment 2",134.92,-6.66,128.26,-1467.4900000000075]
["Payment 3",113.31,14.95,128.26,2876.399999999993,null,"Payment 3",135.6,-7.34,128.26,-1603.0900000000074]
["Payment 4",113.88,14.38,128.26,2762.5199999999927,null,"Payment 4",136.28,-8.02,128.26,-1739.3700000000074]
["Payment 5",114.45,13.81,128.26,2648.069999999993,null,"Payment 5",136.96,-8.7,128.26000000000002,-1876.3300000000074]
["Payment 6",115.02,13.24,128.26,2533.049999999993,null,"Payment 6",137.64,-9.38,128.26,-2013.9700000000075]
["Payment 7",115.59,12.67,128.26,2417.4599999999928,null,"Payment 7",138.33,-10.07,128.26000000000002,-2152.3000000000075]
["Payment 8",116.17,12.09,128.26,2301.2899999999927,null,"Payment 8",139.02,-10.76,128.26000000000002,-2291.3200000000074]
["Payment 9",116.75,11.51,128.26,2184.5399999999927,null,"Payment 9",139.72,-11.46,128.26,-2431.0400000000072]
["Payment 10",117.34,10.92,128.26,2067.1999999999925,null,"Payment 10",140.42,-12.16,128.26,-2571.4600000000073]
["Payment 11",117.92,10.34,128.26,1949.2799999999925,null,"Payment 11",141.12,-12.86,128.26,-2712.580000000007]
["Payment 12",118.51,9.75,128.26,1830.7699999999925,null,"Payment 12",141.82,-13.56,128.26,-2854.4000000000074]
["Total Year 14",1383.88,155.24,1539.12,null,null,"Total Year 17",1656.0800000000002,-116.96,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 15","Principle","Interest","Payment","Balance",null,"Year 18","Principle","Interest","Payment","Balance"]
["Payment 1",119.11,9.15,128.26,1711.6599999999926,null,"Payment 1",142.53,-14.27,128.26,-2996.9300000000076]
["Payment 2",119.7,8.56,128.26,1591.9599999999925,null,"Payment 2",143.24,-14.98,128.26000000000002,-3140.1700000000073]
["Payment 3",120.3,7.96,128.26,1471.6599999999926,null,"Payment 3",143.96,-15.7,128.26000000000002,-3284.1300000000074]
["Payment 4",120.9,7.36,128.26000000000002,1350.7599999999925,null,"Payment 4",144.68,-16.42,128.26,-3428.810000000007]
["Payment 5",121.51,6.75,128.26,1229.2499999999925,null,"Payment 5",145.4,-17.14,128.26,-3574.2100000000073]
["Payment 6",122.11,6.15,128.26,1107.1399999999926,null,"Payment 6",146.13,-17.87,128.26,-3720.3400000000074]
["Payment 7",122.72,5.54,128.26,984.4199999999926,null,"Payment 7",146.86,-18.6,128.26000000000002,-3867.2000000000075]
["Payment 8",123.34,4.92,128.26,861.0799999999925,null,"Payment 8",147.6,-19.34,128.26,-4014.8000000000075]
["Payment 9",123.95,4.31,128.26,737.1299999999925,null,"Payment 9",148.33,-20.07,128.26000000000002,-4163.130000000007]
["Payment 10",124.57,3.69,128.26,612.5599999999924,null,"Payment 10",149.08,-20.82,128.26000000000002,-4312.210000000007]
["Payment 11",125.2,3.06,128.26,487.35999999999245,null,"Payment 11",149.82,-21.56,128.26,-4462.030000000007]
["Payment 12",125.82,2.44,128.26,361.53999999999246,null,"Payment 12",150.57,-22.31,128.26,-4612.600000000007]
["Total Year 15",1469.23,69.89,1539.12,null,null,"Total Year 18",1758.1999999999998,-219.08,1539.12]

{"sheet":"Year 19-24","index":3,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 19","Principle","Interest","Payment","Balance",null,"Year 22","Principle","Interest","Payment","Balance"]
["Payment 1",151.32,-23.06,128.26,-4763.920000000006,null,"Payment 1",181.09,-52.83,128.26,-10746.160000000007]
["Payment 2",152.08,-23.82,128.26000000000002,-4916.000000000006,null,"Payment 2",181.99,-53.73,128.26000000000002,-10928.150000000007]
["Payment 3",152.84,-24.58,128.26,-5068.8400000000065,null,"Payment 3",182.9,-54.64,128.26,-11111.050000000007]
["Payment 4",153.6,-25.34,128.26,-5222.440000000007,null,"Payment 4",183.82,-55.56,128.26,-11294.870000000006]
["Payment 5",154.37,-26.11,128.26,-5376.810000000007,null,"Payment 5",184.73,-56.47,128.26,-11479.600000000006]
["Payment 6",155.14,-26.88,128.26,-5531.950000000007,null,"Payment 6",185.66,-57.4,128.26,-11665.260000000006]
["Payment 7",155.92,-27.66,128.26,-5687.870000000007,null,"Payment 7",186.59,-58.33,128.26,-11851.850000000006]
["Payment 8",156.7,-28.44,128.26,-5844.570000000007,null,"Payment 8",187.52,-59.26,128.26000000000002,-12039.370000000006]
["Payment 9",157.48,-29.22,128.26,-6002.050000000007,null,"Payment 9",188.46,-60.2,128.26,-12227.830000000005]
["Payment 10",158.27,-30.01,128.26000000000002,-6160.320000000007,null,"Payment 10",189.4,-61.14,128.26,-12417.230000000005]
["Payment 11",159.06,-30.8,128.26,-6319.380000000007,null,"Payment 11",190.35,-62.09,128.26,-12607.580000000005]
["Payment 12",159.86,-31.6,128.26000000000002,-6479.240000000007,null,"Payment 12",191.3,-63.04,128.26000000000002,-12798.880000000005]
["Total Year 19",1866.6399999999999,-327.52000000000004,1539.12,null,null,"Total Year 22",2233.81,-694.6899999999999,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 20","Principle","Interest","Payment","Balance",null,"Year 23","Principle","Interest","Payment","Balance"]
["Payment 1",160.66,-32.4,128.26,-6639.900000000007,null,"Payment 1",192.25,-63.99,128.26,-12991.130000000005]
["Payment 2",161.46,-33.2,128.26,-6801.360000000007,null,"Payment 2",193.22,-64.96,128.26,-13184.350000000004]
["Payment 3",162.27,-34.01,128.26000000000002,-6963.630000000007,null,"Payment 3",194.18,-65.92,128.26,-13378.530000000004]
["Payment 4",163.08,-34.82,128.26000000000002,-7126.710000000007,null,"Payment 4",195.15,-66.89,128.26,-13573.680000000004]
["Payment 5",163.89,-35.63,128.26,-7290.600000000008,null,"Payment 5",196.13,-67.87,128.26,-13769.810000000003]
["Payment 6",164.71,-36.45,128.26,-7455.310000000008,null,"Payment 6",197.11,-68.85,128.26000000000002,-13966.920000000004]
["Payment 7",165.54,-37.28,128.26,-7620.850000000008,null,"Payment 7",198.09,-69.83,128.26,-14165.010000000004]
["Payment 8",166.36,-38.1,128.26000000000002,-7787.210000000007,null,"Payment 8",199.09,-70.83,128.26,-14364.100000000004]
["Payment 9",167.2,-38.94,128.26,-7954.410000000007,null,"Payment 9",200.08,-71.82,128.26000000000002,-14564.180000000004]
["Payment 10",168.03,-39.77,128.26,-8122.440000000007,null,"Payment 10",201.08,-72.82,128.26000000000002,-14765.260000000004]
["Payment 11",168.87,-40.61,128.26,-8291.310000000007,null,"Payment 11",202.09,-73.83,128.26,-14967.350000000004]
["Payment 12",169.72,-41.46,128.26,-8461.030000000006,null,"Payment 12",203.1,-74.84,128.26,-15170.450000000004]
["Total Year 20",1981.7900000000002,-442.66999999999996,1539.12,null,null,"Total Year 23",2371.5699999999997,-832.45,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 21","Principle","Interest","Payment","Balance",null,"Year 24","Principle","Interest","Payment","Balance"]
["Payment 1",170.57,-42.31,128.26,-8631.600000000006,null,"Payment 1",204.11,-75.85,128.26000000000002,-15374.560000000005]
["Payment 2",171.42,-43.16,128.26,-8803.020000000006,null,"Payment 2",205.13,-76.87,128.26,-15579.690000000004]
["Payment 3",172.28,-44.02,128.26,-8975.300000000007,null,"Payment 3",206.16,-77.9,128.26,-15785.850000000004]
["Payment 4",173.14,-44.88,128.26,-9148.440000000006,null,"Payment 4",207.19,-78.93,128.26,-15993.040000000005]
["Payment 5",174,-45.74,128.26,-9322.440000000006,null,"Payment 5",208.23,-79.97,128.26,-16201.270000000004]
["Payment 6",174.87,-46.61,128.26,-9497.310000000007,null,"Payment 6",209.27,-81.01,128.26,-16410.540000000005]
["Payment 7",175.75,-47.49,128.26,-9673.060000000007,null,"Payment 7",210.31,-82.05,128.26,-16620.850000000006]
["Payment 8",176.63,-48.37,128.26,-9849.690000000006,null,"Payment 8",211.36,-83.1,128.26000000000002,-16832.210000000006]
["Payment 9",177.51,-49.25,128.26,-10027.200000000006,null,"Payment 9",212.42,-84.16,128.26,-17044.630000000005]
["Payment 10",178.4,-50.14,128.26,-10205.600000000006,null,"Payment 10",213.48,-85.22,128.26,-17258.110000000004]
["Payment 11",179.29,-51.03,128.26,-10384.890000000007,null,"Payment 11",214.55,-86.29,128.26,-17472.660000000003]
["Payment 12",180.18,-51.92,128.26,-10565.070000000007,null,"Payment 12",215.62,-87.36,128.26,-17688.280000000002]
["Total Year 21",2104.04,-564.92,1539.12,null,null,"Total Year 24",2517.83,-978.7099999999999,1539.12]

{"sheet":"Year 25-30","index":4,"n_rows":54,"n_cols":11,"rows_kept":54,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,null,null,"Loan",21393.36]
[null,null,null,"Rate",0.06]
[null,null,null,"Months",360]
[null,null,null,"Years",30]
[null,null,null,"Payment",-128.26]
[]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 25","Principle","Interest","Payment","Balance",null,"Year 28","Principle","Interest","Payment","Balance"]
["Payment 1",216.7,-88.44,128.26,-17904.980000000003,null,"Payment 1",259.32,-131.06,128.26,-26471.780000000002]
["Payment 2",217.78,-89.52,128.26,-18122.760000000002,null,"Payment 2",260.62,-132.36,128.26,-26732.4]
["Payment 3",218.87,-90.61,128.26,-18341.63,null,"Payment 3",261.92,-133.66,128.26000000000002,-26994.32]
["Payment 4",219.97,-91.71,128.26,-18561.600000000002,null,"Payment 4",263.23,-134.97,128.26000000000002,-27257.55]
["Payment 5",221.07,-92.81,128.26,-18782.670000000002,null,"Payment 5",264.55,-136.29,128.26000000000002,-27522.1]
["Payment 6",222.17,-93.91,128.26,-19004.84,null,"Payment 6",265.87,-137.61,128.26,-27787.969999999998]
["Payment 7",223.28,-95.02,128.26,-19228.12,null,"Payment 7",267.2,-138.94,128.26,-28055.17]
["Payment 8",224.4,-96.14,128.26,-19452.52,null,"Payment 8",268.54,-140.28,128.26000000000002,-28323.71]
["Payment 9",225.52,-97.26,128.26,-19678.04,null,"Payment 9",269.88,-141.62,128.26,-28593.59]
["Payment 10",226.65,-98.39,128.26,-19904.690000000002,null,"Payment 10",271.23,-142.97,128.26000000000002,-28864.82]
["Payment 11",227.78,-99.52,128.26,-20132.47,null,"Payment 11",272.58,-144.32,128.26,-29137.4]
["Payment 12",228.92,-100.66,128.26,-20361.39,null,"Payment 12",273.95,-145.69,128.26,-29411.350000000002]
["Total Year 25",2673.1100000000006,-1133.99,1539.12,null,null,"Total Year 28",3198.8900000000003,-1659.77,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 26","Principle","Interest","Payment","Balance",null,"Year 29","Principle","Interest","Payment","Balance"]
["Payment 1",230.07,-101.81,128.26,-20591.46,null,"Payment 1",275.32,-147.06,128.26,-29686.670000000002]
["Payment 2",231.22,-102.96,128.26,-20822.68,null,"Payment 2",276.69,-148.43,128.26,-29963.36]
["Payment 3",232.37,-104.11,128.26,-21055.05,null,"Payment 3",278.08,-149.82,128.26,-30241.440000000002]
["Payment 4",233.54,-105.28,128.26,-21288.59,null,"Payment 4",279.47,-151.21,128.26000000000002,-30520.910000000003]
["Payment 5",234.7,-106.44,128.26,-21523.29,null,"Payment 5",280.86,-152.6,128.26000000000002,-30801.770000000004]
["Payment 6",235.88,-107.62,128.26,-21759.170000000002,null,"Payment 6",282.27,-154.01,128.26,-31084.040000000005]
["Payment 7",237.06,-108.8,128.26,-21996.230000000003,null,"Payment 7",283.68,-155.42,128.26000000000002,-31367.720000000005]
["Payment 8",238.24,-109.98,128.26,-22234.470000000005,null,"Payment 8",285.1,-156.84,128.26000000000002,-31652.820000000003]
["Payment 9",239.43,-111.17,128.26,-22473.900000000005,null,"Payment 9",286.52,-158.26,128.26,-31939.340000000004]
["Payment 10",240.63,-112.37,128.26,-22714.530000000006,null,"Payment 10",287.96,-159.7,128.26,-32227.300000000003]
["Payment 11",241.83,-113.57,128.26000000000002,-22956.360000000008,null,"Payment 11",289.4,-161.14,128.26,-32516.700000000004]
["Payment 12",243.04,-114.78,128.26,-23199.40000000001,null,"Payment 12",290.84,-162.58,128.25999999999996,-32807.54]
["Total Year 26",2838.0099999999998,-1298.8899999999999,1539.12,null,null,"Total Year 29",3396.1900000000005,-1857.0699999999997,1539.12]
[]
[null,null,null,"Total","Loan",{"$nulls":4},"Total","Loan"]
["Year 27","Principle","Interest","Payment","Balance",null,"Year 30","Principle","Interest","Payment","Balance"]
["Payment 1",244.26,-116,128.26,-23443.660000000007,null,"Payment 1",292.3,-164.04,128.26000000000002,-33099.840000000004]
["Payment 2",245.48,-117.22,128.26,-23689.140000000007,null,"Payment 2",293.76,-165.5,128.26,-33393.600000000006]
["Payment 3",246.71,-118.45,128.26,-23935.850000000006,null,"Payment 3",295.23,-166.97,128.26000000000002,-33688.83000000001]
["Payment 4",247.94,-119.68,128.26,-24183.790000000005,null,"Payment 4",296.7,-168.44,128.26,-33985.530000000006]
["Payment 5",249.18,-120.92,128.26,-24432.970000000005,null,"Payment 5",298.19,-169.93,128.26,-34283.72000000001]
["Payment 6",250.42,-122.16,128.26,-24683.390000000003,null,"Payment 6",299.68,-171.42,128.26000000000002,-34583.40000000001]
["Payment 7",251.68,-123.42,128.26,-24935.070000000003,null,"Payment 7",301.18,-172.92,128.26000000000002,-34884.58000000001]
["Payment 8",252.94,-124.68,128.26,-25188.010000000002,null,"Payment 8",302.68,-174.42,128.26000000000002,-35187.26000000001]
["Payment 9",254.2,-125.94,128.26,-25442.210000000003,null,"Payment 9",304.2,-175.94,128.26,-35491.46000000001]
["Payment 10",255.47,-127.21,128.26,-25697.680000000004,null,"Payment 10",305.72,-177.46,128.26000000000002,-35797.18000000001]
["Payment 11",256.75,-128.49,128.26,-25954.430000000004,null,"Payment 11",307.25,-178.99,128.26,-36104.43000000001]
["Payment 12",258.03,-129.77,128.25999999999996,-26212.460000000003,null,"Payment 12",308.78,-180.52,128.25999999999996,-36413.21000000001]
["Total Year 27",3013.0600000000004,-1473.94,1539.12,null,null,"Total Year 30",3605.669999999999,-2066.55,1539.12]

{"sheet":"Sheet2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}